package cn.gson.crm.model.mapper;

import cn.gson.crm.model.pojos.Employee;
import cn.gson.crm.model.pojos.Sell;
import cn.gson.crm.model.pojos.User;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface SellMapper {
    //查询
    public List<Sell> select1(@Param("na") String na);
   //删除
    public int update1(@Param("sellReimburse") String sellReimburse,@Param("sellId") int sellId);
   //查询员工
    public List<Employee> selectEmployee();
    //查询饼状统计图类型数量
    public List<Sell> selltu();
    //查询饼状图经办人数量
    public List<Sell> selltu2();
    //柱状图1
    public List<Sell> sellzhu();
    //柱状图2
    public List<Sell> sellzhu2();
    //获取登陆人
    public List<User> selectUserRole(@Param("yid") int ygId);

}
